﻿CREATE TABLE [dbo].[DatabaseUserRole] (
    [DatabaseUserId] INT NOT NULL,
    [DatabaseRoleId] INT NOT NULL,
    CONSTRAINT [PK_DatabaseUserRole] PRIMARY KEY CLUSTERED ([DatabaseUserId] ASC, [DatabaseRoleId] ASC),
    CONSTRAINT [FK_DatabaseUserRole_DatabaseRole] FOREIGN KEY ([DatabaseRoleId]) REFERENCES [dbo].[DatabaseRole] ([DatabaseRoleId]),
    CONSTRAINT [FK_DatabaseUserRole_DatabaseUser] FOREIGN KEY ([DatabaseUserId]) REFERENCES [dbo].[DatabaseUser] ([DatabaseUserId])
);

